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

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)

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

I already used this trick but It did't work. Can you give me a little sample

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