0 Replies Latest reply: Jul 19, 2013 10:01 AM by mat_243_ RSS

    Transpose interval FROM - TO

      Hi,
      I am quite new with QlikView and now I'm trying to solve the following problem (even don't know if this is possible or not). Let me try to explain.
      As example, I have two tables with the following structure:
      The fist table contains a list of profiles and an interval for each profile. (if the field To is empty the profile has just the value in field from)
      ProfileFromTo
      A001X10
      A002X11X18
      A002L12
      A003M5X15
      In the second table I have an ordered list of all possible values of fields FROM and TO (domain for that field):
      Header 1
      L12
      L15
      M1
      M3
      M5
      X10
      X11
      X15
      X17
      X18
      I would like to obtain a table with stored a row for each profile and any possible value, for our example:
      Header 1Header 2
      A001X10
      A002X11
      A002X15
      A002X17
      A002X18
      A002L12
      A003M5
      A003X10
      A003X11
      A003X15
      Is that possible??
      Thanks in advance,
      Mattia.