Forum Discussion
CSV FILE ERROR IMPORT
Hi All,
i import 3 different csv file, if i sum the value for each csv file the sum is correct, but when i queing these 3 table and sum all value, i receive a different error and the sum is not correct. i can't understand why happen this i'm going crazy
Hi Mike91 -you can appending the three tables, inspect the resulting dataset to ensure there are no duplicates or unexpected rows. Verify that all numeric columns you're summing are in the correct data type.If necessary, use Remove Duplicates on the key columns after appending the data.you are appending the data correctly rather than using an incorrect join type.
Create a new column that sums the values from all three tables after appending, and use that for summation.
Hope the above steps helps in your scenerio, still issue exist could you share more details about the error you're receiving.
2 Replies
Hi Mike91 -you can appending the three tables, inspect the resulting dataset to ensure there are no duplicates or unexpected rows. Verify that all numeric columns you're summing are in the correct data type.If necessary, use Remove Duplicates on the key columns after appending the data.you are appending the data correctly rather than using an incorrect join type.
Create a new column that sums the values from all three tables after appending, and use that for summation.
Hope the above steps helps in your scenerio, still issue exist could you share more details about the error you're receiving.
Thanks, i tried but nothing changed. this 3 file csv contain the same column number and same data type. i queing these 3 table and use a column to filter them for different sales channel, if i check the value from csv channel A the sum of column value are 10 but after the queeing the same channel change the sum value in 5
