The field (column name) of the record wasn't found

[Anonymous]

The source is coming from web in csv format

I have tried the following steps to resolve:

- remove Column=42

- rename column headers to lower case

- duplicating column and then perform split

[Anonymous · Accepted solution]

Removed "promote header" command and had to manually re-name all the columns but it works.

[v-piga-msft]

Hi @Anonymous ,

I'm afraid that the issue should be caused by the step Split columns.

From the query, it seems that the Cost_Center_-_Name wase be changed for Cost_Center_-_Name.1 and Cost_Center_-_Name .2.

After spliting columns, please click refresh and then try to apply and close.

If you still need help, could you share the query which could reproduce the issue so that I could have a test on it? 

In addition, please note do mask your sensitive data before uploading.

Best Regards,

Cherry

[Anonymous]

Hi Cherry,

The data source is web (Workday). While the downloaded csv of the same report works fine but the error results only if the same report is from web source. Unfortunately, I am unable to share the web report access. 

I have also tried duplicating the column and then split the duplicate column but even after that, same error exist "the table wasn't found" while I could see the same column on the file.

many thanks,

Manan