Create new column to file

[adekunah1]

I have sample file ay excel file like below screenshot,

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

Any hints on this?

Thanks in advance.

[bojanvelevski · Accepted solution]

Hi @adekunah1 ,

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

I’ve attached the sample pipeline below

Excel - ETL.slp (7.9 KB)

Regards,
Bojan Velevski

[adekunah1]

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