{
    "title": "Tamir RunningSumDistinctValues",
    "type": "extract",
    "relations": [],
    "datasets": [
        {
            "oid": "df1ad0a9-1337-4dec-bca5-be5c954eff34",
            "fullname": "6c9317e6-0a5b-4432-8edf-5d552cecf38e",
            "type": "custom",
            "name": "6c9317e6-0a5b-4432-8edf-5d552cecf38e",
            "modelingTransformations": [],
            "schema": {
                "tables": [
                    {
                        "oid": "a264d200-603c-401e-8387-977bd1fbfd94",
                        "id": "EarliestDate",
                        "name": "EarliestDate",
                        "type": "custom",
                        "expression": {
                            "oid": "2076275d-22db-4fd3-a0ab-307840bada85",
                            "expression": "SELECT \n    d.[User]\n    ,min(d.[Date])\n    ,concat(tostring(min(d.[Date])),d.[User]) Key\n    ,1 flagEarliest \nFROM [Data] d\nGROUP BY d.[User]"
                        },
                        "columns": [
                            {
                                "oid": "76f74de7-5bc4-4f00-87bd-a28234b6b69a",
                                "id": "User",
                                "name": "User",
                                "type": 18,
                                "size": 65536,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": true,
                                "description": null
                            },
                            {
                                "oid": "fc7c35af-9e67-4e89-b08c-3990f62278ce",
                                "id": "Column",
                                "name": "Column",
                                "type": 19,
                                "size": 0,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": false,
                                "description": null
                            },
                            {
                                "oid": "9b032eef-d2c0-4a23-a3cc-9f55911e5d34",
                                "id": "Key",
                                "name": "Key",
                                "type": 18,
                                "size": 65536,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": true,
                                "description": null
                            },
                            {
                                "oid": "56cbb059-5f7d-4034-a48f-d32a6658a606",
                                "id": "flagEarliest",
                                "name": "flagEarliest",
                                "type": 8,
                                "size": 0,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": false,
                                "description": null
                            }
                        ],
                        "buildBehavior": {
                            "type": "sync",
                            "accumulativeConfig": null
                        },
                        "tupleTransformations": [],
                        "hidden": true,
                        "vTag": "ec187d78-0d5e-4ad0-8014-00dac658c6a5",
                        "configOptions": null,
                        "description": null,
                        "tags": null
                    }
                ]
            },
            "connection": null
        },
        {
            "oid": "5722e976-2fb6-435f-bbf6-610db7e3739e",
            "fullname": "CSV:6757b6c8-56b0-48a6-a693-843c365b4164",
            "type": "extract",
            "name": "6757b6c8-56b0-48a6-a693-843c365b4164",
            "modelingTransformations": [],
            "schema": {
                "tables": [
                    {
                        "oid": "7077b252-f6d1-4eda-a7cb-a095ca264b59",
                        "id": "d92e55d7-f647-4332-af8f-494167433487.csv",
                        "name": "data",
                        "type": "base",
                        "expression": null,
                        "columns": [
                            {
                                "oid": "35770729-242f-43d1-bd2e-bab5d72ebdac",
                                "id": "User",
                                "name": "User",
                                "type": 18,
                                "size": null,
                                "precision": null,
                                "scale": null,
                                "hidden": false,
                                "indexed": true,
                                "description": null
                            },
                            {
                                "oid": "4d3bf9e7-434c-429a-a915-c4c8035c438d",
                                "id": "Date",
                                "name": "Date",
                                "type": 19,
                                "size": null,
                                "precision": null,
                                "scale": null,
                                "hidden": false,
                                "indexed": true,
                                "description": null
                            }
                        ],
                        "buildBehavior": {
                            "type": "sync",
                            "accumulativeConfig": null
                        },
                        "tupleTransformations": [
                            {
                                "arguments": {
                                    "lastUpdated": "2020-03-19T20:47:59.416Z",
                                    "id": "Key",
                                    "name": "Key",
                                    "type": 18,
                                    "size": 65536,
                                    "scale": 0,
                                    "precision": 0,
                                    "oid": "5a9bbae7-ba23-4adc-b180-7fdac6d3b19b",
                                    "hidden": false,
                                    "indexed": true,
                                    "expression": {
                                        "lastUpdated": "2020-03-19T21:02:03.928Z",
                                        "oid": "3330c0ce-ea2e-49f9-9c29-4c9391f44a14",
                                        "expression": "concat(tostring(date),user)"
                                    }
                                },
                                "type": "add-column"
                            }
                        ],
                        "hidden": true,
                        "vTag": "924bd392-0d16-41f7-971c-10c016e15bd2",
                        "configOptions": {
                            "delimiter": ",",
                            "hasHeader": true,
                            "excludeIfBegins": "",
                            "excludeIfContains": "",
                            "stringQuote": "\"",
                            "ignoreFirstRows": "",
                            "culture": "en-US"
                        },
                        "description": null,
                        "tags": null
                    }
                ]
            },
            "connection": {
                "id": "5e73d95d8e81f14344668cb1",
                "provider": "CSV",
                "parameters": "0uJay0RlWn75SYw5xVdoLTtQMy9XvCUj/Fht19g92ZCMMAsC3GNDN13gh6xsXilGEoWFQyoVvqjx/u3Lx3ehg8//c23+YQvqjevR7NZO1sdTWD/xHh1ERcuucg5PSSViihKtt29K9jD668SQFaY58pbLr5KVCOK6pd7q4jF1cu6vRA4QuWsUHndBMB5HPn8D",
                "schema": "C:\\ProgramData\\Sisense\\PrismServer\\FileUploads\\storage\\d9\\d92e55d7-f647-4332-af8f-494167433487.csv",
                "fileName": "data for RunningSumDistinctCount.csv",
                "timeout": 300,
                "autoRefresh": null,
                "refreshRate": null,
                "resultLimit": null,
                "protectedParameters": [],
                "uiParams": {},
                "globalTableConfigOptions": {}
            }
        },
        {
            "oid": "b3d1b550-a1cf-4bb0-a29f-a43ffee3a269",
            "fullname": "6cfef5a5-d56f-4143-a4b9-917d7f987c34",
            "type": "custom",
            "name": "6cfef5a5-d56f-4143-a4b9-917d7f987c34",
            "modelingTransformations": [],
            "schema": {
                "tables": [
                    {
                        "oid": "9170bb5d-4a7a-464b-9c71-1f26f68c83a1",
                        "id": "DataWithEarliestDate",
                        "name": "DataWithEarliestDate",
                        "type": "custom",
                        "expression": {
                            "oid": "3254d648-5711-4e93-bdec-0ef8246c9c7e",
                            "expression": "SELECT \n    d.[Date]\n    ,d.[User]\n    ,e.[flagEarliest]\nFROM [data] d\nLEFT JOIN EarliestDate e\nON d.key = e.[Key]\nOrder By d.[Date]"
                        },
                        "columns": [
                            {
                                "oid": "0ed23e13-f919-49a3-89aa-301a738bcf11",
                                "id": "Date",
                                "name": "Date",
                                "type": 19,
                                "size": 0,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": false,
                                "description": null
                            },
                            {
                                "oid": "aaf9d026-c269-48e4-b0f0-1dccf4749e22",
                                "id": "User",
                                "name": "User",
                                "type": 18,
                                "size": 65536,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": true,
                                "description": null
                            },
                            {
                                "oid": "655f282f-cda0-46cd-870a-7ab697ca341d",
                                "id": "flagEarliest",
                                "name": "flagEarliest",
                                "type": 8,
                                "size": 0,
                                "precision": 0,
                                "scale": 0,
                                "hidden": false,
                                "indexed": false,
                                "description": null
                            }
                        ],
                        "buildBehavior": {
                            "type": "sync",
                            "accumulativeConfig": null
                        },
                        "tupleTransformations": [],
                        "hidden": false,
                        "vTag": "28a5f308-9685-4541-ba91-3a01bd93adca",
                        "configOptions": null,
                        "description": null,
                        "tags": null
                    }
                ]
            },
            "connection": null
        }
    ]
}