Search the Community

Hi, I need some help with converting multiple rows of data, where the rows have the same ID, into one row. Small screenshot below of the data set I am using. The rows of data are duplicating where multiple "Impact" values are selected on a form. I want to merge the Impacts into one row, by matching the ID.

I am joining 2 tables using the query below. Its many to many relationship. The join works fine but creates multiple rows for each item which is expected but the Amount/value column is also duplicated. How to avoid this? Thanks As you can see the Current output the value (50000 appears 3 times instead of 1 and 27000 appears 3 times instead of 1) SELECT * FROM T1 INNER JOIN T2 ON T1.Projectex = T2.WBS_Parent Table 1: +-----------+------------+-----------+----------+--------+----------+-------+ | Projectex | CAPEX_OPEX | costelmnt | sap_vers | Period | FISCYEAR | VALUE | +-----------+------------+-----------+----------+--------+----------+-------+ | 0-01081 | CAPEX | 3416 | 61 | 3 | 2020 | 50000 | | 0-01081 | OPEX | 7077 | 30 | 5 | 2020 | 27000 | +-----------+------------+-----------+----------+--------+----------+-------+ Table2: +------------+-----------------+---------+---------+ | WBS_PARENT | FINANCILAL_YEAR | MEASURE | AMOUNT | +------------+-----------------+---------+---------+ | 0-01081 | 2020 | CPX | 2000000 | | 0-01081 | 2020 | OPX | 50000 | | 0-01081 | 2020 | OPX | 1000000 | +------------+-----------------+---------+---------+ CURRENT OUTPUT: Projectex| CAPEX_OPEX| costelmnt| sap_vers| Period| FISCYEAR| VALUE| 0 0-01081| CAPEX| 3416| 61| 3| 2020| 50000| 1 0-01081| CAPEX| 3416| 61| 3| 2020| 50000| 2 0-01081| CAPEX| 3416| 61| 3| 2020| 50000| 3 0-01081| OPEX| 7077| 30| 5| 2020| 27000| 4 0-01081| OPEX| 7077| 30| 5| 2020| 27000| 5 0-01081| OPEX| 7077| 30| 5| 2020| 27000| WBS_PARENT FINANCILAL_YEAR MEASURE AMOUNT 0 0-01081| 2020| CPX| 2000000 1 0-01081| 2020| OPX| 50000 2 0-01081| 2020| OPX| 1000000 3 0-01081| 2020| CPX| 2000000 4 0-01081| 2020| OPX| 50000 5 0-01081| 2020| OPX| 1000000 Expected Output: Projectex| CAPEX_OPEX| costelmnt| sap_vers| Period| FISCYEAR| VALUE| 0 0-01081| CAPEX| 3416| 61| 3| 2020| 50000| 1 0-01081| CAPEX| 3416| 61| 3| 2020| 2 0-01081| CAPEX| 3416| 61| 3| 2020| 3 0-01081| OPEX| 7077| 30| 5| 2020| 27000| 4 0-01081| OPEX| 7077| 30| 5| 2020| 5 0-01081| OPEX| 7077| 30| 5| 2020| WBS_PARENT FINANCILAL_YEAR MEASURE AMOUNT 0 0-01081| 2020| CPX| 2000000 1 0-01081| 2020| OPX| 50000 2 0-01081| 2020| OPX| 1000000 3 0-01081| 2020| CPX| 4 0-01081| 2020| OPX| 5 0-01081| 2020| OPX|

Hi, I'm new to XSLT and I got some problems with it. I want to merge 2 XML files. I want to copy everything from a main file and a specific element with its childs from a second file into the main root Element. Example: Main File: <?xml version="1.0" encoding="utf-8"?><CAEXFile SchemaVersion="2.15" ...> <InstanceHierarchy Name="Example"> ...A lot of elements... </InstanceHierarchy></CAEXFile> 2nd File: <CAEXFile ...> <SystemUnitClassLib Name="Function"> ...A lot of elements... </SystemUnitClassLib></CAEXFile> Final File: <?xml version="1.0" encoding="utf-8"?><CAEXFile SchemaVersion="2.15" ...> <InstanceHierarchy Name="Example"> ...A lot of elements... </InstanceHierarchy> <SystemUnitClassLib Name="Function"> ...A lot of elements... </SystemUnitClassLib></CAEXFile> My try looks like this: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:template match="CAEXFile"><xsl:copy> <xsl:apply-templates select="@* | node()" /></xsl:copy></xsl:template> <xsl:template match="node() | @*"><xsl:copy-of select="." /></xsl:template> </xsl:stylesheet> It copies the file correct, but how do I get the information out of the 2nd file? I tried something like this: <xsl:apply-templates match="document('my2ndFile.xml')/SystemUnitClassLib/node()" /> but without success. I found some Topics which had the same issue, but it couldn't help me. I'd be very thankful for any help.

Hi all,I have a page where i have lots of images and now after selecting any two images i go to new page and now in this page both the images have a feature of dragging. now i have a button in form saying merge. now if user drags the images in any position suppose one image is overlapping half of other images. now if i click on merge button the images should be merged and save in a new folder. I m using php for it. see attached image. i m using javascript to move the images in the page. now after user drag the two images then after clicking on merge button then the new image should be made. now what i m using is two make a new blank image having the width and height equal to the total of two images. now i m merging my first image to this blank image. by imagecopymerge function then again i m merging the second image to this image by using imagecopy method. but i m not finding the actual coordinate of two pictures and how to find which picture is on top of other.This is my code i know this is not good.$src1 = imagecreatefromjpeg("$image1");$src2 = imagecreatefromjpeg("$image2");header("Content-Type: image/jpg");$im = @imagecreatetruecolor($final_image_width, $final_image_height)or die("Cannot Initialize new GD image stream");$background_color = imagecolorallocate($im, 255, 255, 255);imagecopymerge($im, $src1,$source1_x, $source1_y, 0, 0, $image1_width, $image1_height, 100);imagecopy($im, $src2, $source2_x, $source2_y, 0, 0, $image2_width, $image2_height);header('Content-Type: image/jpg');imagepng($im);