JasonAltenburg Coach

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I think you would be better off doing the SQL step, but I think it is possible in ETL as follows. I utilized the tables from the cross join example on w3resource here After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs',…

I strongly believe it was shortening the name of the input table and the name of the column with sentences in it for step 2 of the SQL transforms down to <10 characters or so, all lowercase. I also added a magic ETL step prior to this where I stripped out null and blank values from the sentences column. (Filter for…

I did find this! What I did was added the LOWER() function to the text field as my first step in the SQL dataflow. UPDATE table_name SET sentences = LOWER(sentences)

Wow what a journey that was to get it working... I ensured that blank and null values were stripped in my dataflow. I then shortened my table names, in reality my table name was closer to 40 characters and my column name was 22 characters. I shortened these down to about 10 characters each through renaming/data flows. In…

Datamaven, I'm trying to work with this today (it must be in the air). I'm having trouble with step 2. When I copy/paste and modify the code as directed from call_transform_2.sql I'm getting an error. here's my code: #Word Cloud V2 #Example: CALL word_cloud('sample_word_cloud_nolan', '`Sentence`' , 'y','y' ); CALL…

You would need to combine the INSTR,SUBSTRING, and LENGTH functions to do this in a beast mode. With that being said, I STRONGLY ADVISE AGAINST DOING THIS IN A BEAST MODE. But you asked if it was possible... and it is... but it causes what seems to be A LOT of validation time on my 4 line dataset consisting of the…