Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Workflow not reading all the rows in CSV en

Avatar

Avatar
Validate 10
Level 2
gunjans6748888
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
gunjans6748888
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
gunjans6748888
Level 2

09-02-2018

Hi all,

I have created a workflow to read individual rows from CSV and process them. the workflow structure is below

file transfer > data loading > enrichment > JS to process enrichment > test condition > master JS to process the customer data > end

I am able to see my entries flowing till test condition but master JS is only processing the last entry from the CSV file. When i tried putting a forEach() loop, it took the last row from CSV and processed it again and again.

How can I read and process all the rows from CSV flowing through the above workflow.

Note : ["JS to process enrichment" is able to read all the rows in CSV as I have applied ForEach loop]

Thanks,

Accepted Solutions (0)

Answers (4)

Answers (4)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

12-03-2018

Hi,

Any update on this?

Florent

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

09-02-2018

Hi Gunjan,

it's nearly impossible to debug without looking at your JS and workflow; please post your workflow and js here.

Regards,

Amit

Avatar

Avatar
Validate 10
Level 2
gunjans6748888
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 2
gunjans6748888
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
gunjans6748888
Level 2

09-02-2018

Hi Florent.

In the "JS to process Enrichment", we have put forEach loop. Now, when we are forwarding the data from this stage, it is only forwarding the last data processed in the forEach loop.

Should we define an array to forward all the data to the Master JS?

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

09-02-2018

Hi Gunjan,

So, from what you say, are you able to tell which transition does not contain all the data you need? Does the output transition of the test contains all rows?

Florent