Hi,
this works very well on my data, thank you very much! The dummy data I posted was simplified, which is why I get some clutter in the transformed table. The real data looks like this:
6388700277 27 attribution 1486110252126 anb_3=-1&uids=6331855527&anb_2=xpv&anb_1=-1&anb_0=-1&promo_3=-1&promo_2=-1&promo_1=-1&promo_0=-1&entrysourceID_3=-1&entrysourceID_2=-1&entrysourceID_1=-1&entrysourceID_0=-1&akt_3=-1&akt_2=-1&akt_1=-1&akt_0=-1&wid_3=6388700277&version_3=-1&wid_2=6385404791&version_2=-1&wid_1=6379987259&version_1=-1&wid_0=6375153270&version_0=-1
Your extraction works fine for all fields but the first field where it should only read "anb_3". The values "27" and "attribution" are fixed "1486110252126" is different for every ID:
id field value
6388700277 27 attribution 1486110252126 anb_3 -1
6388700277 uids 6331855527
6388700277 anb_2 xpv
6388700277 anb_1 -1
6388700277 anb_0 -1
6388700277 promo_3 -1
6388700277 promo_2 -1
6388700277 promo_1 -1
6388700277 promo_0 -1
6388700277 entrysourceID_3 -1
6388700277 entrysourceID_2 -1
6388700277 entrysourceID_1 -1
6388700277 entrysourceID_0 -1
6388700277 akt_3 -1
6388700277 akt_2 -1
6388700277 akt_1 -1
6388700277 akt_0 -1
6388700277 wid_3 6388700277
6388700277 version_3 -1
6388700277 wid_2 6385404791
6388700277 version_2 -1
6388700277 wid_1 6379987259
6388700277 version_1 -1
6388700277 wid_0 6375153270
6388700277 version_0 -1
Best regards
Sascha
... View more