Skip to Content
0

Load data using Data Services 4.2 with changing columns ?

Mar 03, 2017 at 12:34 AM

30

avatar image

Hi all looking for pointers on if/how it's possible to do regular Data Services 4.2 loads for data (in csv or excel format) which contains a key column along with a changing number of columns/data in different orders each time it is loaded & from which only specific columns need to be loaded? P.S. The file is generated by an API which cannot be changed.

i.e. Only want to load any of : key# plus ItemA and/or ItemB and/or ItemC and/or ItemD and/or ItemE,

Load 1 Contains:

key#,ItemA, ItemB, ItemC,ItemD, ItemE, ItemF, ItemG, ItemH

Load 2 Contains:

key#,ItemA, ItemJ, ItemK, ItemC, ItemD, ItemL, ItemJ, ItemE

Load 2 Contains:

key#,ItemJ, ItemB, ItemL, ItemK, ItemC,ItemJ,ItemF

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers