Log In
Register
Home
June 18, 2019
Offline
Excel file is attached
July 16, 2010
Offline
Nothing attached, Nadeem. Also, please state your question in the forum as opposed to only in the file. This helps others search for help on the same topic.
Thanks,
Mynda
June 18, 2019
Offline
I have two .CSV files. First file has (A,B,C,D) columns while (AA,BB,A,B,C,D) in 2nd file.
I want to append data from first file to 2nd file according to their columns (A,B,C,D) but data appends in first 4 columns (AA,BB,A,B).
Is any way to append data according to right columns.
(I have more then 50 products in file. Products sale depends on according to seasons. So products increase or decrease after two or three months)
July 16, 2010
Offline
Hi Nadeem,
When you get files from a folder it requires those files to have the same file structure i.e. column labels if you want to append on import.
If your files have a different structure, then you could try adding a file to the folder that contains headings for each product possible across all 50 files, a dummy file if you like. Use that as your Sample file (available after clicking the double headed arrow to expand the Content Binary files, then the other files should append to it by correctly mapping the column headings to the dummy file.
Mynda
June 18, 2019
Offline
I already used this trick but It did't work. Can you give me a little sample
July 16, 2010
Offline
If it didn't work maybe you need to add one row of data to the file that you later filter out.
e.g.
Date AA BB A B C D
1/1/2999 1 1 1 1 1 1
Tip: choose a date that is way outside your usual date range so it's easy to filter out.
Mynda
1 Guest(s)
