topic Re: Permutations withouth repeat in App Development

Permutations without repeat

fheidenstecker — Mon, 09 Jul 2018 08:20:27 GMT

Hi There,

i have 3 values and i want to combine these 3 without repeat

The 3 values are John, George and Paul (sorry Ringo 😉 )

That is the result I want to have

John

George

Paul

John George

John Paul

Paul George

John George Paul

What algorithm could create this result? I tried karthesian product, but this causes repeats , for example

John Goerge

George John

and so on.

I really would appriciate a hint!

Thanks,

Fabian

Re: Permutations withouth repeat

sunny_talwar — Mon, 09 Jul 2018 12:52:50 GMT

May be this

Table:

LOAD * INLINE [

Name1

John

George

Paul

];

Left Join (Table)

LOAD Name1 as Name2

Resident Table;

Left Join (Table)

LOAD Name1 as Name3

Resident Table;

TempTable:

CrossTable (Header, Name)

LOAD RowNo() as RowNum,

Name1,

Name2,

Name3

Resident Table;

FinalTable:

LOAD Distinct Name;

LOAD RowNum,

Concat(DISTINCT Name, ',') as Name

Resident TempTable

Group By RowNum;

DROP Table Table, TempTable;

Re: Permutations withouth repeat

fheidenstecker — Mon, 09 Jul 2018 13:31:08 GMT

What a clever use of crosstable!

Thanks stalwar1‌

Re: Permutations withouth repeat

sunny_talwar — Mon, 09 Jul 2018 13:34:05 GMT

Hahaha yes, I am glad we were able to figure it out using CrossTable()