Forum Discussion

antoineL's avatar
antoineL
Frequent Visitor
5 years ago

Decoding GS1-128 packed data into separate AIs

Hi. Newbie user of PowerQuery, so please excuse me is there is an obvious answer in the documentation, which I did not fully read before asking.   GS1-128 is a barcode encoding where the data are s...
Tutorial Requests
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi antoineL ,

If all fields in the coumn have the same length and format, you can use split columns in power query directly, please refer:

  1. Split columns by number of characters 
  2. How to Split Columns in Power BI 

 

If not, I think need to group them first which have the same length and format and then use split columns by number of characters.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.