I have an old ERP system. The upload function is one line per value. So if I want to upload 7 models I need 7 lines, not one line with Qty of 7
however my source system sends the data as one line with Qty of 7
DLM2245/17 DLM2245/17X 1
DLP2204/17 DLP2204/17X 7
DLP2249/17 DLP2249/17X 7
DLV1004/17 DLV1004/17X 147
DLV1005/17 DLV1005/17X 158
DLV1009/17 DLV1009/17X 187
so in this example line 1 is fine. But line two needs 7 lines, and line 3 needs 7 lines and line 4 147 lines etc etc etc
so this is how the first three lines would look in the query.
DLM2245/17 DLM2245/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
any help is appreciated.
however my source system sends the data as one line with Qty of 7
DLM2245/17 DLM2245/17X 1
DLP2204/17 DLP2204/17X 7
DLP2249/17 DLP2249/17X 7
DLV1004/17 DLV1004/17X 147
DLV1005/17 DLV1005/17X 158
DLV1009/17 DLV1009/17X 187
so in this example line 1 is fine. But line two needs 7 lines, and line 3 needs 7 lines and line 4 147 lines etc etc etc
so this is how the first three lines would look in the query.
DLM2245/17 DLM2245/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2204/17 DLP2204/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
DLP2249/17 DLP2249/17X
any help is appreciated.