concate a string with an unknown number of rows

mathias_schnoor

Hey !


I want concate a urlstring with an unknown number of rows from two different data input tools.

Example:
First data_source one row

RecordIdFirstdatasource a      b   

1             50  480

Second data-source N rows

RecordIdSecondDataSource,  f, g

1    9.48577    53.95809
2    9.54651    53.89993
3    9.50688    53.97195
...

Pseudo code (like java):

String myurl:= "myurlstring?";

String x:= 50;
String y:= 480;
StringBuffer sb = new StengBuller();
sb.append(myurl);

for(int i=0; i< SecondDataSource.size; i++)
{
   sb.append("foo");
    sb.append(i);
    sb.append("="+x);

   sb.append("&bah");
    sb.append(i);
    sb.append("="+y);

  sb.append("&myattribute");
    sb.append(i);
     sb.append(=SecondDataSource.at(i).g);
   sb.append(",");

    sb.append(=SecondDataSource.at(i).f) ;
...
}

Result string:
myurl?foo1=50&bah1=480&myattribute1=9.48577, 53.95809&&foo2=50&bah2=480&myattribute2=9.54651,53.89993&foo3=..&bah3=..&myattribute=.., ..

Is that possible to build in Alteryx?

Mathias

chris_love

Ah sorry one last step I missed is to summarize the parameters using Summarize tool and Concatenate result3 (see 1 in image) options.

Notice in Concatenate option in Summarize you can set the delimiter to "&" as you need (see 2 in image).

You'll probably want to also take the group by myURL field too to preserver that... 

Chris