Forum Discussion
Append Table as new - different column Types with same column name?
Hi All, So I came accross this strange behaviour when trying to append a table and then merging this table with another query. Table 1 Column 1 Type Text Column 2 Type Any Column 3 Type Whol...
- Hi Anonymous,
This is an intended behaviour. Type any means that column may contain any type, but joins respect typisation.
1 does not equal "1", ie number and text aren't equal. You can observe precisely exact behaviour in Excel vlookup - mixing numbers and text that look like numbers make vlookup behave seemingly weird.
In your case you have exactly this numbers mixed with text that look like numbers - hence the column type switches to any as PBI does not take responsibility for converting tyles behind the scene.
Kind regards,
JB
Hi Anonymous,
This is an intended behaviour. Type any means that column may contain any type, but joins respect typisation.
1 does not equal "1", ie number and text aren't equal. You can observe precisely exact behaviour in Excel vlookup - mixing numbers and text that look like numbers make vlookup behave seemingly weird.
In your case you have exactly this numbers mixed with text that look like numbers - hence the column type switches to any as PBI does not take responsibility for converting tyles behind the scene.
Kind regards,
JB
This is an intended behaviour. Type any means that column may contain any type, but joins respect typisation.
1 does not equal "1", ie number and text aren't equal. You can observe precisely exact behaviour in Excel vlookup - mixing numbers and text that look like numbers make vlookup behave seemingly weird.
In your case you have exactly this numbers mixed with text that look like numbers - hence the column type switches to any as PBI does not take responsibility for converting tyles behind the scene.
Kind regards,
JB