topic Re: Re: How to split column value in to multiple column values in QlikView https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496718#M1127058 <HTML><HEAD></HEAD><BODY><P>See the attached.&nbsp; I'm not sure how your addresses are set up as they look different from what I'm used to, so you may have to do some other configurations on your own.&nbsp; The base of what you need is there.</P></BODY></HTML> Tue, 17 Dec 2013 16:20:13 GMT Nicole-Smith 2013-12-17T16:20:13Z How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496711#M1127051 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>Please find attached. Could anyone help me how to split the Address column so that I need to have below columns in Straight table.</P><P></P><P>Address1, Address2, Address3, Town,County,Postcode.</P><P></P><P>I tried using Subfield function but it is not showing correct values.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 17 Dec 2013 15:26:10 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496711#M1127051 2013-12-17T15:26:10Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496712#M1127052 <HTML><HEAD></HEAD><BODY><P>If your address-column always equally structured subfield is the proper functions:</P><P></P><P>....</P><P>subfield(AddressColumn, ',', 1) as Adress1,</P><P>subfield(AddressColumn, ',', 2) as Adress2</P><P>....</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 17 Dec 2013 15:42:22 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496712#M1127052 marcus_sommer 2013-12-17T15:42:22Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496713#M1127053 <HTML><HEAD></HEAD><BODY><P>Thanks Marcus.</P><P></P><P>But the address column is not equally structured that's the problem I was facing now. Please any help.</P><P></P><P></P><P><BR /> </P></BODY></HTML> Tue, 17 Dec 2013 15:44:14 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496713#M1127053 2013-12-17T15:44:14Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496714#M1127054 <HTML><HEAD></HEAD><BODY><P>Then you need some checks (length, char-count, purgechar/keepchar, wildmatch/index, mid ...) for each subfield, perhaps nested in if-loops. Is there are only a few possibilities is it simply, if not you need some time for complicated routines ... Sometimes is it better to ask for a better data-sources ...</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 17 Dec 2013 16:00:31 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496714#M1127054 marcus_sommer 2013-12-17T16:00:31Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496715#M1127055 <HTML><HEAD></HEAD><BODY><P>Thanks and any example for purgechar/keepchar please?</P></BODY></HTML> Tue, 17 Dec 2013 16:01:39 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496715#M1127055 2013-12-17T16:01:39Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496716#M1127056 <HTML><HEAD></HEAD><BODY><P>See the attached.</P></BODY></HTML> Tue, 17 Dec 2013 16:05:23 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496716#M1127056 Nicole-Smith 2013-12-17T16:05:23Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496717#M1127057 <HTML><HEAD></HEAD><BODY><P>Thanks but I need postcode not to split i,e I should have postcode as WA4 1ER.</P><P></P><P>Please help how to get this.</P></BODY></HTML> Tue, 17 Dec 2013 16:17:23 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496717#M1127057 2013-12-17T16:17:23Z Re: Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496718#M1127058 <HTML><HEAD></HEAD><BODY><P>See the attached.&nbsp; I'm not sure how your addresses are set up as they look different from what I'm used to, so you may have to do some other configurations on your own.&nbsp; The base of what you need is there.</P></BODY></HTML> Tue, 17 Dec 2013 16:20:13 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496718#M1127058 Nicole-Smith 2013-12-17T16:20:13Z Re: How to split column value in to multiple column values https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496719#M1127059 <HTML><HEAD></HEAD><BODY><P>Thanks will try and let you know.</P></BODY></HTML> Tue, 17 Dec 2013 16:25:58 GMT https://community.qlik.com/t5/QlikView/How-to-split-column-value-in-to-multiple-column-values/m-p/496719#M1127059 2013-12-17T16:25:58Z