topic Re: Left join based on a period in QlikView https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549762#M691106 <HTML><HEAD></HEAD><BODY><P>Yahtzee!&nbsp; Exactly what I needed.&nbsp; Appreciate your help!&nbsp; Have a great day!</P></BODY></HTML> Thu, 29 Aug 2013 17:33:51 GMT Anonymous 2013-08-29T17:33:51Z Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549756#M691100 <HTML><HEAD></HEAD><BODY><P>Good day.&nbsp; Trying to join some information based on fields that are not unique.&nbsp; So what would the script be to separate it out.</P><P></P><P>162.3.&nbsp; Where everything before the first period is what I want to call Task List ID.&nbsp; Everything between the periods I want to call Task Number.</P><P></P><P>So I want to separate based on the periods.&nbsp; The two files are Excel so when I load the files.&nbsp; This field comes in as xls. rather than delimited type.</P></BODY></HTML> Thu, 29 Aug 2013 16:21:07 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549756#M691100 Anonymous 2013-08-29T16:21:07Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549757#M691101 <HTML><HEAD></HEAD><BODY><P>Well, your files aren´t showing up. Maybe you should re-upload them</P></BODY></HTML> Thu, 29 Aug 2013 16:34:53 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549757#M691101 Clever_Anjos 2013-08-29T16:34:53Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549758#M691102 <HTML><HEAD></HEAD><BODY><P>Sorry...didn't upload.&nbsp; Do you need them?</P><P><BR /> </P></BODY></HTML> Thu, 29 Aug 2013 16:36:57 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549758#M691102 Anonymous 2013-08-29T16:36:57Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549759#M691103 <HTML><HEAD></HEAD><BODY><P>Trying to figure out what you really want, could you give us more information?</P></BODY></HTML> Thu, 29 Aug 2013 16:38:36 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549759#M691103 Clever_Anjos 2013-08-29T16:38:36Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549760#M691104 <HTML><HEAD></HEAD><BODY><P>SOrry for the delay...I don't know where the button is to upload the file</P></BODY></HTML> Thu, 29 Aug 2013 16:59:03 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549760#M691104 Anonymous 2013-08-29T16:59:03Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549761#M691105 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>subfield(yourfield,'.',1) as First,</P><P>subfield(yourfield,'.',2) as Second</P><P>FROM yourexcel</P></BODY></HTML> Thu, 29 Aug 2013 17:23:17 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549761#M691105 Clever_Anjos 2013-08-29T17:23:17Z Re: Left join based on a period https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549762#M691106 <HTML><HEAD></HEAD><BODY><P>Yahtzee!&nbsp; Exactly what I needed.&nbsp; Appreciate your help!&nbsp; Have a great day!</P></BODY></HTML> Thu, 29 Aug 2013 17:33:51 GMT https://community.qlik.com/t5/QlikView/Left-join-based-on-a-period/m-p/549762#M691106 Anonymous 2013-08-29T17:33:51Z