Solving Inconsistent Data Issues
Recently our team came across an issue with CSV files. The order of the columns did not match and the columns were fixed. We had a problem with accessing the variables. This is how we solved it. To Fix this we have created a CSV that will have the order of columns that is required. Then we have added a Data Concatenator module. Firstly add the Data Input module having correct ordered input CSV file and then connect the input CSV having columns with different order. When we proof it, it will show the order of Data Order File which was added in 1st connector of Data Concatenator module.