Forum Discussion

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
4 years ago
Solved

Dataformat error: we couldn't convert to Number issue

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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 

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

Hi, SantoshKumar 

 

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

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
4 years ago

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