VlookUp Error

[murtazaali233]

Hi Guys,

I fetch my data from a folder first. Im trying to perform a vlook up by merging my 2 queries. The problem arising is that all my data is not being picked up. I believe the reason is that data in the column(tracking_number) is stored as text whereas it needs to be stored as number. As you can see in the picture below, the data in tracking_number column has both text and numbers but the format is text.

When I tried to change the format to number. Error is coming.

Please help guys. Is there any way out of this ?

 

[sandy666]

maybe try = Table.SplitColumn(previous_step, "tracking_number", Splitter.SplitTextByPositions({0, 2}, false), {"tracking_number.1", "tracking_number.2"})

 

[sandy666]

or a bit shorter = Table.SplitColumn(previous_step, "tracking_number", Splitter.SplitTextByPositions({0, 2}, false))