on 09-25-2013 5:11 PM
Right now I have an Attribute view pulling from 5 different tables with different data. They are all connected with an ID.
I have a .csv file with columns that need to be uploaded to all 5 tables. The .csv columns dont have the same names as the current columns, but I can change this if i need to.
Right now I am importing the selected columns to each table and after I'm done they show up in my Attribute View fine.
I was just wondering if there is an easier way to do this, instead of importing the csv 5 different times.
Thanks
Hi Connor,
Within the HANA studio I guess there is no such feature but thinking out of the box it is possible in SAP Business Objects Data Services (ETL) where we can create batch job in which data flow contains as many flat files (CSV/excel) you want, do the transformations and run the job.
The output will be tables will be created in HANA.
Regards
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Connor,
The only way to load the CSV files to "n" number of tables with automation is SAP BODS.
Please go through the suggestion which was provided by "Raj".
Regards,
Krishna Chaitanya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.