Router configuration
Hi Team,
I need some help in router configuration.
I have snap execute where we select data and want to push to different target tables based on theater column.
how to put the condition
theat...
Forum Discussion
So in my use case, its simple: I have 5 input documents, each document is an array of values.
e.g. the first array has 3 values, the 2 array has 2 values.
after the CSV formatter, i want to see 5 documents/files( the first one should have 3 rows, the second one should have 2 rows…)
The 5 documents comes out of a mapper snap, then I tried to put a CSV formatter snap behind the mapper, i noticed that the number of output of the CSV is not 5, but 1 document contains all values across all arrays.
Then I tried to move just the CSV formatter to a subpipeline, I got the same result.
Since the CSV Formatter currently doesn’t work with arrays, you will need to use a child pipeline that splits the array into separate docs that go into a CSV Formatter.
I’m attaching a couple of pipelines to demonstrate this flow:
FormatArrayToCSV_2019_02_28.slp (5.6 KB)
WriteCSVFiles_2019_02_28.slp (5.4 KB)
The FormatArrayToCSV pipeline is the child. It splits the “$array” property in the incoming document and then passes the results to a CSV Formatter and FileWriter. You’ll need to change the JSON Splitter to split your array property.
The WriteCSVFiles pipeline is the parent. It just contains some mock data and feeds it into the child pipeline.
It is because the
parsemethod expects a number but you are providing a string value.
You need to parse the “Modified_Date”, you can do so by usingparseInt(string).In your case would be:
parseInt($Modified_Date)And the full expression to format the date would be:
Date.parse(parseInt($Modified_Date))Hi @ykoppisetty
You can use the
Date.parse()function.
You need to pass the unix timestamp as a parameter.Input
Date.parse(1445910469510)Output
2015-10-27T01:47:49.510 Etc/UTCThank You @j.angelevski, @shashish.jha for helping me on this use case.
Hi @j.angelevski can you tell how to get dynamically?
For example, the below field contain all the UNIX date formats so how to get normal date formats dynamically?
Modified_Date
1445910469510
1443298668240
1428458098640Date.parse($your_input_date).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”})
You can change your desired formatting in this section : “format”:“yyyy-MM-dd HH:mm:ss”
Place this expression into mapper snap and dynamically your_input_date will be picked up and formatted accordingly.Hi @j.angelevski @shashish.jha
When I am trying through dynamically I am getting the below error.Can you please resolve this error. I have also tried the @shashish.jha formula. But that’s also getting error. Please help me on this.
Thank you.
If that is the field you have in the input document, then you can simply use:
Date.parse($Modified_Date)
