Forum Discussion

saipawar's avatar
saipawar
Icon for Helper IV rankHelper IV
6 years ago
Solved

How to create word cloud from a column that has multiple values in a single row?

Hi, Here's  a business question I'd like to answer with my data -  Q) What topics is my audience the most interested in? A form is filed out by the attendees from where they pick the topics. Here...
Need Help
saipawar's avatar
saipawar
Icon for Helper IV rankHelper IV
6 years ago

Hi Greg_Deckler ,

 

Thanks for responding so quickly.

 

So here's what I understand - 

a. VAR __Column1 to VAR __Column7 are the columns generated using the delimiter?

b. To create an attribute called Table, I need to "Add New Column " by right clicking on the dataset on the Visualization page

c. Which is [Column 1] in your query? When are these generated?

 

Can you maybe use some dummy names for the tables and columns?

 

Thanks.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

No, you would use New Table to create a new table in your data model. [Column 1], [Column 2] ... are the columns created when you split out your original column. I am creating variables (__Column1, __Column2...) to hold their contents and then using UNION to append them all together.

  • saipawar's avatar
    saipawar
    Icon for Helper IV rankHelper IV
    6 years ago

    Okay.. I think I am getting it. Just a little more help in the beginning of the query.

    Looks like I am messing up the syntax when creating a new table 

     

    Can you please check the syntax for the first two lines? I tried the open and closed braces. 

     

    Thanks for being patient with me.

     

    Cheers.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Sure, 

       

      Table = 

      VAR col1 = ...

       

      col1 will be the name of your variable.

      • saipawar's avatar
        saipawar
        Icon for Helper IV rankHelper IV
        6 years ago

        That worked!! Thanks Greg_Deckler You're awesome😎