output csv header and line relationship

[Tan Tran]

Hallo everyone,

Typical question and hope someone can give a better idea.

We received 810 contains multiple articles merged together.

We then translated to 2 csv files: 

1. header csv contains invoice, PO etc... 
2. lines APN, per item $ etc...

We then ingest these 2 files into 2 tables in database.

We need a unique key in header + lines csv file so that we can join 2 tables.

I tried transform.unique('1') and pass value into csv field called "transno". However, in the lines csv, transno is alway +1 with header csv because of the chain translation.

Can you please shed some direction on this one?

Thank you so much!

Tan.T

[Eppye Bots]

I tried transform.unique('1') and pass value into csv field called "transno". However, in the lines csv, transno is alway +1 with header csv because of the chain translation.

so....substract 1 in 2nd translation?

kind regards, Henk-Jan Ebbers

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/9ec0b2c2-7834-44bf-971a-76b8bb8569a1n%40googlegroups.com.

[Tan Tran]

Hi Henk-Jan,

Yes, that sound logic.

But when I tried  transform.unique('-1') or  transform.unique('transno')-1, I got error.

That is correct syntax for -1?

[Tan Tran]

Hi Henk-Jan,

Nevermind.

I found another way to add transno outside of BOTS.

Great software and thank you so much for your time

Regards,

Tan.T