Create new column to file

I have sample file ay excel file like below screenshot,

image

I am trying to add another field or column in the input file in my snaplogic pipeline and look like below screenshot.

image

Any hints on this?

Thanks in advance.

Hi @adekunah1 ,

You can achieve this with a Mapper and the snap.in.totalCount function which counts the incoming documents. Here is the result:

image

I’ve attached the sample pipeline below

Excel - ETL.slp (7.9 KB)

Regards,
Bojan Velevski

2 Likes

@bojanvelevski thank you so much. It has helped a lot. I am new to Snaplogic workspace and working on some pipelines.

1 Like