Dataformat error: we couldn't convert to Number issue

[SantoshKumar]

Hi ,

I am trying to Left Outer Join the two excel data here. ->  lets say Table1, Table2.

Below is my condition: Left Outer (All from first, matching from Second)

I have used ID coumns from the both tables and since few values are of alphanumeric like cac123 etc, i made sure that both ID columns are in Text format.

I was able to apply the Left Outer Join but when i tried to Expand the second table(table2) in the MergedTable , it throws me an  error as " Dataformat error: we couldn't convert to number: Details  C15810"

Any help is greatly appreciated.

Thanks

Santosh 

[ALLUREAN]

Hi, @SantoshKumar 

Would you attach a picture of tables headers and 1-2 rows with data?

[SantoshKumar]

@ALLUREAN thanks for looking into my issue but its a transformation post that caused the issue and at now, it is corrected.

[amitchandak · Accepted solution]

@SantoshKumar , with this error, it seems like still in one of the tables, the data type is not text. Make sure you have changed it in correct table. Or there is transformation post that causing it 

[SantoshKumar]

@amitchandak you were right. i took all the steps which i have performed on the data and its look like,

at first the ID column which was in Text format - i have changed it to Numeric and later on i rechanged it agian to Text format.
by removing the wrong step : which is changing the format to numeric, i was able to resolve the issue.
I could say its an Human error but accept your suggestion as a solution for my question.

Thanks again !!

[SantoshKumar]

@amitchandak Yes , i have crossed checked the data type on the both tables and amde sure both are text before merging them. looking for any alternate solutions to solve the issue.

[amitchandak]

@SantoshKumar , Can you a sample pbix after removing sensitive data.