Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement where I need to load 10 CSV files in to one CSV file and from that one CSV file I need to load the table in Datawarehouse.
All the 10 CSV files have the same column structure and will not be changing.
Can you please let me know the job flow of how to achieve this.
Thank You.
Thanks for the quick reply.
Do I need to create 10 different metadata for the 10 different CSV I have?
Thanks TRF I was able to acheive my requirement based on the flow you provided.
The other thing I was asked today was to create a LOAD_DATE column in the output CSV file and the load date should be based on the date which is a part of the name of the source CSV files.
For Instance name of one of the source csv files is All_VM_Cluster_Stats_2018-11-04.
When the data from this file is loaded to the target output csv file, LOAD_DATE column should be populated with '2018-11-04'
Please explain how to achieve this.
- tFileList to iterate over the 10 input files
- tFileInputDelimited to read the content of the current file using https://fetlife.vip/ https://downloader.vip/imvu/ https://downloader.vip/canva/