Forum Discussion

arb1782's avatar
arb1782
Icon for Helper III rankHelper III
5 years ago
Solved

Challenge with split columns by delimiter

Hi   I have data across 6 columns and the data is in two formats depending on the data source. I want to achieve the following:   Category Value Category 1 X, x and x Category 2 Y, y ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi arb1782 

If you've got data from 2 sources in different formats, why not take the data from each source into its own query and avoid this problem?

Phil

  • arb1782's avatar
    arb1782
    Icon for Helper III rankHelper III
    5 years ago

    Hi PhilipTreacy 

     

    There are 2 sources but the data is in a single database table with another field that implies the source.