none
Flat file dissasemble with timestamp

    Question

  • Hi folks!

    I have a problem i need some help with. Hopefully someone out there has stombled upon this before.

    I'm going to call a database procedure with some customer information(parameters found in TH tag), and 24 values (parameters found in TV tag, 1 tag pr hour). My problem is that i can get alot more than 24 TV values after an TH tag(max 24*31), so i must group them by date and order them from hour 00 - > 23 and ad the belonging TH record to all instances, so i can call my procedure witch must have 24 values.

    Any good ideas?

    I have a flat file that looks like this:

    --------------------------------------------

    TH;param;param;param;param;

    TV;value;timestamp

    TV;value;timestamp

    TV;value;timestamp

    TH;param;param;param;param;

    TV;value;timestamp

    TV;value;timestamp

    TV;value;timestamp

    -------------------------------------


    Br. Kim Atle Norén
    Tuesday, March 22, 2011 1:03 PM

Answers